[dbo].[Individual]

Property	Value
Created	10:31:25 AM Tuesday, March 02, 2010
Last Modified	1:17:33 PM Thursday, February 23, 2012

	Name	Data Type	Max Length (Bytes)
$Indexes IX_Individual_PrimaryInstituteContactKey: ContactKey\PrimaryInstituteContactKey$	ContactKey	uniqueidentifier	16
	PrefixCode	nvarchar(25)	50
	FirstName	nvarchar(20)	40
	MiddleName	nvarchar(20)	40
	LastName	nvarchar(30)	60
	SuffixCode	nvarchar(10)	20
	Designation	nvarchar(20)	40
	Informal	nvarchar(20)	40
	Gender	nchar(1)	2
	BirthDate	datetime	8
$Indexes IX_Individual_PrimaryInstituteContactKey: ContactKey\PrimaryInstituteContactKey$	PrimaryInstituteContactKey	uniqueidentifier	16
	PrimaryInstituteName	nvarchar(80)	160
	PrimaryInstituteTitle	nvarchar(80)	160

	Name	Columns	Unique
	PK_Individual	ContactKey
	AK_Individual_PrimaryInstituteContactKey	PrimaryInstituteContactKey
	IX_Individual_FirstName	FirstName
	IX_Individual_LastName	LastName
	IX_Individual_PrefixCode	PrefixCode
	IX_Individual_PrimaryInstituteContactKey	ContactKey, PrimaryInstituteContactKey
	IX_Individual_SuffixCode	SuffixCode

Name	Columns
FK_Individual_ContactMain	ContactKey->[dbo].[ContactMain].[ContactKey]
FK_Individual_Institute_Primary	PrimaryInstituteContactKey->[dbo].[Institute].[ContactKey]
FK_Individual_PrefixRef	PrefixCode->[dbo].[PrefixRef].[PrefixCode]
FK_Individual_SuffixRef	SuffixCode->[dbo].[SuffixRef].[SuffixCode]

SQL Script

CREATE TABLE [dbo].[Individual]
(
[ContactKey] [uniqueidentifier] NOT NULL,
[PrefixCode] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirstName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiddleName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SuffixCode] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Designation] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Informal] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Gender] [nchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BirthDate] [datetime] NULL,
[PrimaryInstituteContactKey] [uniqueidentifier] NULL,
[PrimaryInstituteName] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrimaryInstituteTitle] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Individual] ADD CONSTRAINT [PK_Individual] PRIMARY KEY CLUSTERED ([ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Individual_PrimaryInstituteContactKey] ON [dbo].[Individual] ([PrimaryInstituteContactKey]) INCLUDE ([ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Individual_FirstName] ON [dbo].[Individual] ([FirstName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Individual_LastName] ON [dbo].[Individual] ([LastName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Individual_PrefixCode] ON [dbo].[Individual] ([PrefixCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [AK_Individual_PrimaryInstituteContactKey] ON [dbo].[Individual] ([PrimaryInstituteContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Individual_SuffixCode] ON [dbo].[Individual] ([SuffixCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Individual] ADD CONSTRAINT [FK_Individual_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO
ALTER TABLE [dbo].[Individual] ADD CONSTRAINT [FK_Individual_Institute_Primary] FOREIGN KEY ([PrimaryInstituteContactKey]) REFERENCES [dbo].[Institute] ([ContactKey])
GO
ALTER TABLE [dbo].[Individual] ADD CONSTRAINT [FK_Individual_PrefixRef] FOREIGN KEY ([PrefixCode]) REFERENCES [dbo].[PrefixRef] ([PrefixCode])
GO
ALTER TABLE [dbo].[Individual] ADD CONSTRAINT [FK_Individual_SuffixRef] FOREIGN KEY ([SuffixCode]) REFERENCES [dbo].[SuffixRef] ([SuffixCode])
GO